fairnesscoop /
permacoop
| Total Complexity | 2 |
| Total Lines | 34 |
| Duplicated Lines | 0 % |
| Changes | 0 | ||
| 1 | import {MigrationInterface, QueryRunner} from 'typeorm'; |
||
| 2 | |||
| 3 | export class FileAndPaySlip1588080086043 implements MigrationInterface { |
||
| 4 | name = 'FileAndPaySlip1588080086043'; |
||
| 5 | |||
| 6 | public async up(queryRunner: QueryRunner): Promise<any> { |
||
| 7 | await queryRunner.query( |
||
| 8 | `CREATE TABLE "file" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "name" character varying NOT NULL, "size" integer NOT NULL, "mimeType" character varying NOT NULL, "uploadedAt" TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, CONSTRAINT "PK_36b46d232307066b3a2c9ea3a1d" PRIMARY KEY ("id"))`, |
||
| 9 | undefined |
||
| 10 | ); |
||
| 11 | await queryRunner.query( |
||
| 12 | `CREATE TABLE "pay_slip" ("id" uuid NOT NULL DEFAULT uuid_generate_v4(), "date" TIMESTAMP NOT NULL, "fileId" uuid NOT NULL, "userId" uuid NOT NULL, CONSTRAINT "PK_6a3474cef7b4be2033694e1b2ae" PRIMARY KEY ("id"))`, |
||
| 13 | undefined |
||
| 14 | ); |
||
| 15 | await queryRunner.query( |
||
| 16 | `ALTER TABLE "pay_slip" ADD CONSTRAINT "FK_252d4cbbedfa1f1fb66ada01a07" FOREIGN KEY ("fileId") REFERENCES "file"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, |
||
| 17 | undefined |
||
| 18 | ); |
||
| 19 | await queryRunner.query( |
||
| 20 | `ALTER TABLE "pay_slip" ADD CONSTRAINT "FK_e70c3a9343494ab691a33302fe5" FOREIGN KEY ("userId") REFERENCES "user"("id") ON DELETE NO ACTION ON UPDATE NO ACTION`, |
||
| 21 | undefined |
||
| 22 | ); |
||
| 23 | } |
||
| 24 | |||
| 25 | public async down(queryRunner: QueryRunner): Promise<any> { |
||
| 26 | await queryRunner.query( |
||
| 27 | `ALTER TABLE "pay_slip" DROP CONSTRAINT "FK_e70c3a9343494ab691a33302fe5"`, |
||
| 28 | undefined |
||
| 29 | ); |
||
| 30 | await queryRunner.query( |
||
| 31 | `ALTER TABLE "pay_slip" DROP CONSTRAINT "FK_252d4cbbedfa1f1fb66ada01a07"`, |
||
| 32 | undefined |
||
| 33 | ); |
||
| 34 | await queryRunner.query(`DROP TABLE "pay_slip"`, undefined); |
||
| 35 | await queryRunner.query(`DROP TABLE "file"`, undefined); |
||
| 36 | } |
||
| 38 |
